This page last changed on Feb 14, 2008.

Selecting Stored Procedure Objects for Import

To create physical data services based on stored procedures:

  1. Select the Stored Procedures option.
  2. Click Next.  

A list of available stored procedures appears.

Objects are grouped based on the relational data sources catalog and/or schema.

You can use wildcards to support importing metadata on internal stored procedures. For example, entering the following string as a stored procedure filter:

%TRIM%
retrieves metadata on the system stored procedure:
STANDARD.TRIM

In such a situation you may want to make a "nonsense" entry in the Table/View field in order to avoid retrieving all tables and views in the database.

Database-specific Catalog and Schema Considerations

Simply check the desired objects or their container, which will select all enclosed stored procedures.

Stored Procedure Objects Selected for Import

Document generated by Confluence on Jan 13, 2009 15:57